package com.monitor.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.monitor.entity.ErpBidata;

/**
 * <p>
 * 车辆BI表 Mapper 接口
 * </p>
 *
 * @author LX
 * @since 2018-09-12
 */
public interface ErpBidataMapper extends BaseMapper<ErpBidata> {
	@Select("select * From erp_bidata b where b.cus_id in (${cusids})")
	public List<ErpBidata> selectByCusids(@Param("cusids")String cusids);
	
	@Select("SELECT * FROM erp_bidata WHERE car_plate=#{plate}")
	public ErpBidata selectByPlate(@Param("plate")String plate);
}
